﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_GROUPS_SE')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_GROUPS_SE
	END

GO

CREATE PROCEDURE [dbo].[PRC_TB_GROUPS_SE]
AS
	SELECT 
		a.TG_ID, 
		a.TG_NAME, 
		a.TG_IDENTIFICATION, 
		a.TG_DESCRIPTION
	FROM TB_GROUPS a
	ORDER BY a.TG_NAME


GO

GRANT EXEC ON dbo.PRC_TB_GROUPS_SE TO PUBLIC

GO

